When you define a database library in SAS^® Management Console, you choose one of three possible values for the Authentication Type field for the database server connection for that library. The three choices for the Authentication Type field are as follows:

• (none) specifies that credentials are not used to connect to the server.
• User/Password specifies that credentials are retrieved from metadata corresponding to the selected authentication domain.
• Prompt specifies that the user is prompted for credentials when connecting to the server.

If you set the Authentication Type to Prompt to create a database server for the database library in SAS Management Console, you might not be able to open a table from SAS Enterprise Guide from this library. The following error might occur:

If you want SAS Enterprise Guide to prompt you for a database user ID and password, follow the steps in SAS Note 46674: "How to have SAS^® Enterprise Guide^® prompt you for a database user ID and password."

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Enterprise Guide	Microsoft® Windows® for x64	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Microsoft Windows Server 2003 Datacenter Edition	4.3		9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	4.3		9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	4.3		9.2 TS2M3
		Microsoft Windows Server 2003 for x64	4.3		9.2 TS2M3
		Microsoft Windows Server 2008	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Microsoft Windows Server 2008 for x64	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Microsoft Windows XP Professional	4.3		9.2 TS2M3
		Windows 7 Enterprise 32 bit	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Enterprise x64	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Home Premium 32 bit	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Home Premium x64	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Professional 32 bit	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Professional x64	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Ultimate 32 bit	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows 7 Ultimate x64	4.3	6.1	9.2 TS2M3	9.4 TS1M3
		Windows Vista	4.3		9.2 TS2M3
		Windows Vista for x64	4.3		9.2 TS2M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Attempting to open a database table from SAS Enterprise Guide might result in the following error: "Open data operation failed [ERROR] No terminal connected to the SAS session when opening a DBMS table from SAS Enterprise Guide"

Type:	Problem Note
Priority:	high
Topic:	Data Management ==> data management

Date Modified:	2015-11-09 13:16:48
Date Created:	2013-05-20 15:57:37